Tabela TreatmentStandard

Definicja tabeli TreatmentStandard

Name

TreatmentStandard

Code

TreatmentStandard

Comment

 


Lista kolumn tabeli TreatmentStandard

Name

Code

TreatmentStandardID

TreatmentStandardID

Active

Active

TreatmentStandTypeID

TreatmentStandTypeID

MinistryURL

MinistryURL

StartDT

StartDT

StopDT

StopDT

ModificationDT

ModificationDT

CommentsID

CommentsID

Sex

Sex

AvgTreatmentTime

AvgTreatmentTime

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna TreatmentStandardID tabeli TreatmentStandard

Definicja kolumny TreatmentStandardID tabeli TreatmentStandard

Name

TreatmentStandardID

Code

TreatmentStandardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli TreatmentStandard

Definicja kolumny Active tabeli TreatmentStandard

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

No

Comment

 


Kolumna TreatmentStandTypeID tabeli TreatmentStandard

Definicja kolumny TreatmentStandTypeID tabeli TreatmentStandard

Name

TreatmentStandTypeID

Code

TreatmentStandTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MinistryURL tabeli TreatmentStandard

Definicja kolumny MinistryURL tabeli TreatmentStandard

Name

MinistryURL

Code

MinistryURL

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna StartDT tabeli TreatmentStandard

Definicja kolumny StartDT tabeli TreatmentStandard

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli TreatmentStandard

Definicja kolumny StopDT tabeli TreatmentStandard

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ModificationDT tabeli TreatmentStandard

Definicja kolumny ModificationDT tabeli TreatmentStandard

Name

ModificationDT

Code

ModificationDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CommentsID tabeli TreatmentStandard

Definicja kolumny CommentsID tabeli TreatmentStandard

Name

CommentsID

Code

CommentsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Sex tabeli TreatmentStandard

Definicja kolumny Sex tabeli TreatmentStandard

Name

Sex

Code

Sex

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AvgTreatmentTime tabeli TreatmentStandard

Definicja kolumny AvgTreatmentTime tabeli TreatmentStandard

Name

AvgTreatmentTime

Code

AvgTreatmentTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli TreatmentStandard

Definicja kolumny InsertingPerson tabeli TreatmentStandard

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli TreatmentStandard

Definicja kolumny InsertDate tabeli TreatmentStandard

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LastModifiedPerson tabeli TreatmentStandard

Definicja kolumny LastModifiedPerson tabeli TreatmentStandard

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli TreatmentStandard

Definicja kolumny LastModifiedDT tabeli TreatmentStandard

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli TreatmentStandard

Name

Code

Primary

PK_TreatmentStandard

PK_TreatmentStandard

X


Klucz PK_TreatmentStandard tabeli TreatmentStandard

Definicja klucza PK_TreatmentStandard tabeli TreatmentStandard

Name

PK_TreatmentStandard

Code

PK_TreatmentStandard

Primary

Yes

Comment